Fullscreen Image

Accruent Data Connect Introduction

Accruent Data Connect is an add‑on feature, also included in the asset-based advanced package, that gives you direct and secure access to cloud data in a BI‑ready format. You can analyze Accruent data using your own business intelligence (BI), analytics, and enterprise tools, without manual exports or custom integrations.

With Accruent Data Connect, you can:

  • Connect directly to BI tools such as Power BI or Tableau.

  • Use trusted, consistent datasets for reporting and analytics.

  • Scale analytics without affecting operational performance.

  • Build a foundation for advanced analytics and AI initiatives.

Accruent Data Connect delivers structured, governed operational data through Snowflake. Your analytics‑ready data stays aligned as source data changes. Accruent manages data delivery and governance so you can focus on insights and decisions, not data preparation.

Workflow

  1. We extract and model data from Accruent cloud products.

  2. We push the data to Snowflake.

  3. Snowflake delivers the datasets to your BI and analytics tools.

Accruent Data Connect for Maintenance Connection

When you use Accruent Data Connect with Maintenance Connection, you get analytics‑optimized data for work orders and assets, with access to multiple individual tables, including:

  • Work orders

  • Assets

  • Preventive maintenance (PM)

  • Procedures

  • Labor

  • Repair centers

  • Purchase orders

  • Classifications and related reference data

The data refreshes every 1 to 4 hours.

Snowflake access options

You access Data Connect through Snowflake using one of these options:

  • Accruent Snowflake: If your company doesn’t use Snowflake as your enterprise data warehouse, we offer a Snowflake Reader account.

  • Owned Snowflake: If your company uses Snowflake as your enterprise data warehouse, we provide a native Snowflake-to-Snowflake data sharing, delivering BI-ready MC data directly into your Snowflake.

View data in Snowflake

Contact your Accruent representative for licensing information and Snowflake access credentials. Accruent provides the login URL, username, and password you need to sign in.

  1. In the left navigation, select Catalog.

  2. Expand the primary data share that matches your company name.

  3. Select one of the following schemas:

    • Schema ending in Presentation: Transformed, BI‑friendly data, including views and dimension (DIM) tables.

    • Schema ending in Raw: Source‑level data in its original database format, including table names from Maintenance Connection.

Connect Snowflake to BI tools

Your data team can connect Snowflake to BI and analytics tools. To do this, you need your Snowflake role and warehouse information.

  1. Sign in to Snowflake.

  2. In the left navigation, select your username.

  3. Select Preferences.

  4. In the Defaults section, locate the role and warehouse values.